<?php session_start(); 
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 */
if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{   
    if(isset($_SESSION['type']))
    {
        if($_SESSION['type'] == 'administrator')
        {
           ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Classes</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav { 
	  width:210px;
	  height:auto;
	  border:thin solid #09C;
	  margin-left: 10px;
	  text-align : center;}
	  
.mainline { 
	  width:712px;
	  height:auto;
	  text-align : center;}


</style></head>
<center>
<body bgcolor="#FFFFFF">
<body>

<div id="wrapper">
	<div id="header">
    <h1></h1>
    </div>
    
    <div id="header2">
    	<h3></h3>
 	</div>
  
	<div id="nav">
      <?php include 'admin_navigation.php';?>
    </div>
	
    <div id="mainline">
        <h4>View Classes</h4>
    

  <div id="body">
  <form action=admin_classaction.php method=POST>	
    <table width="700" height="auto" cellpadding="3" cellspacing="1" align="center">
        <tr height="40" bgcolor="LightSteelBlue">
            <th>Subject</th>
            <th>Section</th>
			<th>Room / Schedule</th>
			<th>Tutor</th>
			<th>Date</th>
			<th>Action</th>
        </tr>
            <?php
           
            include ('connection.inc');
            
            $sql = "SELECT * FROM classes order by class_id";
			$result = pg_query($sql);
            $count = pg_num_rows($result);
            if($count<1)
            {
            	echo "</table>";
            	echo "<br>No classes";
            }
            else
            {
            	
	            for($i = 0; $i < $count; $i++)
	            {
	                $class_id = pg_fetch_result($result, $i, 'class_id');
					$class_subj = pg_fetch_result($result, $i, 'subject');
					$section = pg_fetch_result($result, $i, 'section');
					$tutor = pg_fetch_result($result, $i, 'teacher_id');
					$num_students = pg_fetch_result($result, $i, 'num_students');
					$start_date = pg_fetch_result($result, $i, 'startdate');
	                $time = date_create_from_format('Y-m-d', $start_date);
	                $startdate= date_format($time, 'M-d-Y');
					
					$end_date = pg_fetch_result($result, $i, 'enddate');
					$time = date_create_from_format('Y-m-d', $end_date);
	                $enddate= date_format($time, 'M-d-Y');
					$room_id = pg_fetch_result($result,$i, 'room_id');
					
					$query = "SELECT * FROM rooms where room_id='$room_id'";
           			$qresult= pg_query($query);
           			$capacity = pg_fetch_result($qresult, 0, 'capacity');
           			
					$starttime= pg_fetch_result($result, 'starttime');
					$endtime= pg_fetch_result($result, 'endtime');
					$sql = "SELECT * FROM teachers natural join users where teacher_id='$tutor'";
           			$result1 = pg_query($sql);
           			$lastname = pg_fetch_result($result1, 0, 'lastname');
           			$firstname = pg_fetch_result($result1, 0, 'firstname');
	                echo "<tr height=\"30\" bgcolor=\"#f5f5f5\">
						<td align=\"center\">$class_subj</td>
	                	<td align=\"center\">$section</td>
						<td align=\"center\">$room_id / $starttime - $endtime</td>
						<td align=\"center\">$lastname, $firstname</td>
						<td align=\"center\">$startdate to $enddate</td>";
	                if($num_students<$capacity)
	                {
	                	echo "<td align=\"center\"><input type=submit name=\"action\" value=\"Add Student $class_id\"  /><input type=submit name=\"action\" value=\"View Class List $class_id\"  /></td>";
	                }
					else
					{
						echo "<input type=submit name=\"action\" value=\"View Class List $class_id\"  /></td>";
					} 
					echo "</tr>";
	            }
               echo "</table>";
            }
        ?>    
	</div>
	</div>
	
	  
	
      <p align="justify"><br />
      </p>
    
    
    <br class="clearfloat">
	<br />
    
    <div id="footer">
    <p align="center">
    Tutorial Business Manager: info@tbms.com <br />Credits/Engineers: Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan; Manzano, Audrey Ann; Ng, Sheila Regine<br />
    <br />copyright 2011</p>
    </div>
</div>
</div>
</body>
</html>            
  <?php
        }
        elseif($_SESSION['type'] == 'student')
        {
            header('Location: student_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'tutor')
        {
            header('Location: tutor_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'parent')
        {
            header('Location: parent_index.php');
            exit();
        }
    }
}
else
{
    header('Location: index.php');
}
?>
